import json

news_table_structure = {
        "table_name": "news",
        "columns": [
            {
                "name": "id",
                "type": "INT",
                "attributes": ["AUTO_INCREMENT", "PRIMARY KEY"]
            },
            {
                "name": "title",
                "type": "VARCHAR(255)",
                "attributes": ["NOT NULL"]
            },
            {
                "name": "publication_date",
                "type": "DATETIME",
                "attributes": ["NOT NULL"]
            },
            {
                "name": "source",
                "type": "VARCHAR(255)",
                "attributes": []
            },
            {
                "name": "summary",
                "type": "TEXT",
                "attributes": []
            },
            {
                "name": "content",
                "type": "LONGTEXT",
                "attributes": []
            },
            {
                "name": "category",
                "type": "VARCHAR(100)",
                "attributes": []
            },
            {
                "name": "author",
                "type": "VARCHAR(255)",
                "attributes": []
            },
            {
                "name": "image_url",
                "type": "VARCHAR(500)",
                "attributes": []
            },
            {
                "name": "views",
                "type": "INT",
                "attributes": ["DEFAULT 0"]
            },
            {
                "name": "likes",
                "type": "INT",
                "attributes": ["DEFAULT 0"]
            },
            {
                "name": "created_at",
                "type": "TIMESTAMP",
                "attributes": ["DEFAULT CURRENT_TIMESTAMP"]
            },
            {
                "name": "updated_at",
                "type": "TIMESTAMP",
                "attributes": ["DEFAULT CURRENT_TIMESTAMP", "ON UPDATE CURRENT_TIMESTAMP"]
            }
        ]
    }





